#!/usr/bin/env python
#coding=utf-8
from pysqlite2 import dbapi2 as sqlite

con = sqlite.connect('/home/jay/stock.db')
c = con.cursor()
create_prices = "create table prices (id integer primary key,\
                                      date text not null default current_date,\
                                      code text not null,\
                                      high real , low real, open real, close real,adj_close real,\
                                      volume int, change real);"
c.execute(create_prices)
con.commit()


c.close()
con.close()
